<%@ page language="java" contentType="text/html"%>
<%@ page import="javax.xml.transform.stream.StreamSource" %>
<%@ page import="javax.xml.transform.stream.StreamResult" %>
<%@ page import="java.io.FileOutputStream" %>
<%@ page import="javax.xml.transform.TransformerFactory" %>
<%@ page import="javax.xml.transform.Transformer" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>

<%@ page import="javax.xml.parsers.*"%>
<%@ page import="javax.xml.transform.*"%>
<%@ page import="javax.xml.transform.dom.*"%>
<%@ page import="javax.xml.transform.stream.*"%>
<%@ page import="javax.servlet.jsp.*"%>
<%@ page import="javax.servlet.jsp.tagext.*"%>
<%@ page import="org.w3c.dom.*"%>
<%@ page import="org.xml.sax.*"%>

<%@ include file="includes\connectionToDB.jsp" %> 
<%
    
          String urlLink = request.getParameter("url");
	   
		/* NEW STUFF */
			String id = request.getParameter("id");
		
			Calendar cal = Calendar.getInstance(TimeZone.getDefault());
			
			java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("dd-MM-yy");
			sdf.setTimeZone(TimeZone.getDefault());          
			
			String dateTime = sdf.format(cal.getTime());	
		
			Statement s_updateLastRead = con.createStatement();
			s_updateLastRead.executeUpdate("UPDATE UserFeed SET lastread = '"+dateTime+"' WHERE feedid = " + id+ ";");
		
		/* NEW STUFF */
    

	   
	   	try 
		{
			DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance();
			dbf.setNamespaceAware(true);
			
			DocumentBuilder db = dbf.newDocumentBuilder();
			Document body = db.parse(new InputSource(urlLink));
			
			Document xslDom = db.parse(pageContext.getServletContext().getRealPath("webreader/xsl/readfeed.xsl"));
			
			Transformer transformer = TransformerFactory.newInstance().newTransformer(new DOMSource(xslDom));
			transformer.transform(new DOMSource(body),new StreamResult(out));
		} 
		catch(Exception e) 
		{
			throw new JspException(e.getMessage());
		}
	   
	   
	con.close();
%>